table lock造句

• This option only requires an intent - shared table lock
  用户必须是表所有者，或者是
• It must acquire a shared table lock
  运行dbcc checktable ，则必须获取一个共享表锁。
• Similarly , page locks are always escalated to table locks
  同样，页锁始终升级到表锁。
• Are tables locked during snapshot generation
  快照生成期间是否锁定表？
• Table locks are applied for the duration of the index operation
  在索引操作期间应用表锁。
• Long - term table locks are not held for the duration of the index operation
  在索引操作期间不持有长期表锁。
• Long - term table locks are not held
  不保留长期表锁。
• If table locking is specified , the default setting for the table set with
  使用表级锁定如果指定了表锁定，则使用
• If table locking is not used , the default uses row - level locks , unless the
  如果未使用表锁定，默认使用行级锁定，除非
• Specifies that row locks are taken when page or table locks are ordinarily taken
  指定通常采用页锁或表锁时，采用行锁。
• Table locking behavior
  表锁定行为
• Read operations acquire no page or row locks ; only sch - s table locks are acquired
  读取操作不获取页锁或行锁，只获取sch - s表锁。
• The following partial transaction shows how to place an explicit shared table lock on
  上放置一个显式共享表锁，以及如何读取索引。
• Table locks are applied and the table is unavailable for the duration of the index operation
  应用表锁，该表在索引操作期间不可用。
• Exclusive table locks are held only for a very short amount of time during the alteration process
  更改过程中，排他表锁只保留非常短的时间。
• The sql server 2005 database engine will not escalate row or page locks to table locks
  Sql server 2005数据库引擎不会将行锁或页锁升级到表锁。
• Sets the locking behavior for a table during a bulk - import operation . table lock on bulk import
  选项可以设置大容量导入操作过程中针对表的锁定行为。
• If holdlock is also specified , the shared table lock is held until the end of the transaction
  如果同时指定了holdlock ，那么，在事务结束之前将一直保持该共享表锁。
• Causes dbcc checktable to obtain a shared table lock instead of using an internal database snapshot
  可使dbcc checktable获得一个共享表锁，而不使用内部数据库快照。
• Table locking can improve performance of the bulk - import operation by reducing lock contention on the table
  表锁定可以通过减少表中的锁争用来提高大容量导入操作的性能。